﻿CREATE TABLE [dbo].[Accessory_Tbl] (
    [ID]                 INT            IDENTITY (1, 1) NOT NULL,
    [AccessoryID]        INT            NULL,
    [AccessoryItemID]    INT            NULL,
    [Accessory]          NVARCHAR (MAX) NULL,
    [MultiplierID]       INT            NULL,
    [ColourUsageID]      INT            NULL,
    [Discount]           FLOAT          NULL,
    [MadeInHouse]        BIT            NULL,
    [Unit]               NVARCHAR (MAX) NULL,
    [AccessoryDetail]    NVARCHAR (MAX) NULL,
    [AccessoryDetail2]   NVARCHAR (MAX) NULL,
    [Price]              FLOAT          NULL,
    [TierPriceIndicator] NVARCHAR (MAX) NULL
);

